﻿CREATE TABLE [flcr].[PORTFOLIO] (
    [PORTFOLIO_ID]      INT           NOT NULL,
    [AUDIT_USER]        VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]        DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]     INT           NOT NULL,
    [AUDIT_MOD_USER]    VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]    DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ] INT           NOT NULL,
    [ACTIVE_FLG]        BIT           NOT NULL,
    [PORTFOLIO_NAME]    VARCHAR (100) NOT NULL,
    [PORTFOLIO_DESC]    VARCHAR (250) NOT NULL,
    [PORTFOLIO_TYPE]    INT           NOT NULL,
    [DOMAIN_ID]         INT           NOT NULL,
    [PARENT_ID]         INT           NOT NULL,
    [ACCT_BUDGET_ID]    INT           NOT NULL
);



